CREATE EXTERNAL TABLE `jms_dim`.`dim_sys_network_detail_hi`(
    `id` bigint COMMENT '主键ID'
    , `code` string COMMENT '编号'
    , `name` string COMMENT '名字'
    , `city_id` bigint COMMENT '城市ID'
    , `city_desc` string COMMENT '城市'
    , `area_id` bigint COMMENT '区/县ID'
    , `area_desc` string COMMENT '区/县'
    , `type_id` bigint COMMENT '网点类型ID'
    , `type_desc` string COMMENT '网点类型描述'
    , `is_delete` int COMMENT '是否删除:1未删除,2已删除'
    , `create_time` timestamp COMMENT '创建时间'
    , `update_time` timestamp COMMENT '更新时间'
    , `is_entrepot` int COMMENT '是否集散'
    , `opening_time` timestamp COMMENT '开通时间'
   , `regional_id` bigint COMMENT '大区ID'
    , `regional_desc` string COMMENT '大区名称'
    , `area_info_id` bigint COMMENT '片区ID'
    , `area_info_desc` string COMMENT '片区名称'
    , `provider_id` bigint COMMENT '省份ID'
    , `provider_desc` string COMMENT '省份'
   )
COMMENT '网点资料'
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
WITH SERDEPROPERTIES (
  'serialization.format' = '1'
)
STORED AS
  INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION '/dw/hive/jms_dim.db/external/dim_sys_network_detail_hi';